UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zw9a6t4c5dqSHndF+UvX3MxrqaYfao5NgSFtrNWgnP8='
WHERE
key_id = 'c96a780b8f354a1dd82e49265e1d75abd8acc1ae7e98718c91c561f101efc030'
AND (
token = 'Zw9a6t4c5dqSHndF+UvX3MxrqaYfao5NgSFtrNWgnP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)