UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYrdvxoxaYRmTY4v9ItGkG3hrI6Mz6OQ06NCUK8CZfY='
WHERE
key_id = '5f864d0f611e2b12a295adc0f433f2c91081075898a48f293b3a5f4e4e7dbfcc'
AND (
token = 'ZYrdvxoxaYRmTY4v9ItGkG3hrI6Mz6OQ06NCUK8CZfY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)