UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vSYuYVhmKQLvjtT0LdGAEjnFQyVtUHa/nyXnSUUuCkA='
WHERE
key_id = 'cfa275dd63825dbccaf9c18deaf8064ca4fbdb4e39c73aabd8c5fc80dae205bd'
AND (
token = 'vSYuYVhmKQLvjtT0LdGAEjnFQyVtUHa/nyXnSUUuCkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)