UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JlzL90dXXueCRpI9o6Lre7OlwHZRNeefmGfWnKxWZH8='
WHERE
key_id = '67b17e6b6609bd78b88033f8a67c3750d28ad78b97dbe74854880e9f4db62178'
AND (
token = 'JlzL90dXXueCRpI9o6Lre7OlwHZRNeefmGfWnKxWZH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)