UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vg2R5+hYm/W7+mSeViSAqX4uoC1fbvcM6JgKRVwWYiU='
WHERE
key_id = '48f34c89f4655b4b129efab271505452ad4c2b355292864a896c9e3578b56ddd'
AND (
token = 'vg2R5+hYm/W7+mSeViSAqX4uoC1fbvcM6JgKRVwWYiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)