UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfDJaWFVW8U/F9W5nE/MaNll9MLMBTeCcE9kVMcclSk='
WHERE
key_id = '1daf4454e75c3ce9c50e77924c5b3467db01be8eb3e04874508af846566574a5'
AND (
token = 'xfDJaWFVW8U/F9W5nE/MaNll9MLMBTeCcE9kVMcclSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)