UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1LXSiIYDJN71IMgGEjg36Fxo3NvrnM2F1JZLk4F3gtc='
WHERE
key_id = 'bb56ebfd93816c96101faa874aefb33659d2342a18b9c1196456bdf2bc0f604f'
AND (
token = '1LXSiIYDJN71IMgGEjg36Fxo3NvrnM2F1JZLk4F3gtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)