UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M5I7pug+987ZEPGDbh94VpsldDiJ0cBjSywwrt3sgqM='
WHERE
key_id = '0d9053034ffd366a4f8adac16c92e123fc1c9d6c5baf78a29c59507bb6d29cac'
AND (
token = 'M5I7pug+987ZEPGDbh94VpsldDiJ0cBjSywwrt3sgqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)