UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a/IR+xenrkPf/RkmiepPZGfAdJ/LBSMcpc5VuYA/OPk='
WHERE
key_id = 'e5675b5fe5303870e68df761b3bb8776fe1fc936073dba3d0bd09a99bcfe1d4a'
AND (
token = 'a/IR+xenrkPf/RkmiepPZGfAdJ/LBSMcpc5VuYA/OPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)