UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9Bq3wcCUJOWygxAvnZ8F0oMXA7gMvBbEKbQLpDhEk0='
WHERE
key_id = '4a7f22823a8b8e65f5e2fec8183b96badc6868902972ae1d9669a475802a8c06'
AND (
token = 'H9Bq3wcCUJOWygxAvnZ8F0oMXA7gMvBbEKbQLpDhEk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)