UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5frgv8J5kfmqfeDioIk6DU2HXndbCg7J7UHSADU5JJE='
WHERE
key_id = 'e069850064928549cfa2723599af6f340876b6154185795df9e0b3f0898785dc'
AND (
token = '5frgv8J5kfmqfeDioIk6DU2HXndbCg7J7UHSADU5JJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)