UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KTKfa5VHkT7wd8jZzrMBMitg7LnP2bqaWHVMwgWMEMg='
WHERE
key_id = 'f6001b5ae10f43d8501ffdfcbc181f9a5657e12b694542caa6c7d68cd3a81174'
AND (
token = 'KTKfa5VHkT7wd8jZzrMBMitg7LnP2bqaWHVMwgWMEMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)