UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VB8MgL5QKz3UQFFsS7EcFhfOqUyI1nRaSY3OJUmJjzA='
WHERE
key_id = 'b9d407507b44131b08a9a922eafab95f694bbf31dc397d740d89a2e48c1db280'
AND (
token = 'VB8MgL5QKz3UQFFsS7EcFhfOqUyI1nRaSY3OJUmJjzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)