UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J5n3XET9tvX/Ma2WIDuyA23wRkFQV6eNPfoFn187vxA='
WHERE
key_id = '4711268bf700bf172ea218dc74556b87653703cc196ba1801e31eb637090b3a3'
AND (
token = 'J5n3XET9tvX/Ma2WIDuyA23wRkFQV6eNPfoFn187vxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)