UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yXLcQIwAgzs+7bE94GUem7+SBrCAdK5ybslyOKj0B+k='
WHERE
key_id = '87ee41c778f49677dd0fe122fd7b613690361608ca2cee7f6a0de3cb5173e00b'
AND (
token = 'yXLcQIwAgzs+7bE94GUem7+SBrCAdK5ybslyOKj0B+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)