UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XfAmgDSH4NsVk/2OXcedspGOXML9b0mb6xLjjwJ3RbU='
WHERE
key_id = '3ccbc498471bf5991b6190a9962fb7563c1eadf590a75682e7a816969da039b6'
AND (
token = 'XfAmgDSH4NsVk/2OXcedspGOXML9b0mb6xLjjwJ3RbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)