UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9XczIYk4nU1GJ6VD7OxBD/9APCpz8va5rIZ8CpaZVDM='
WHERE
key_id = 'cb4e1b49dcd1a6bb7f72df64f0dcc36a12afc726f453f6be9d24591bee6a1acc'
AND (
token = '9XczIYk4nU1GJ6VD7OxBD/9APCpz8va5rIZ8CpaZVDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)