UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vKJf7vZlx/8h09x7X5rbBhYojhE4SHx4ZongyxTpREE='
WHERE
key_id = '1f2f89039baed7b12524db5b7bdf3de6884f29e05d12567b636276b99b8e7806'
AND (
token = 'vKJf7vZlx/8h09x7X5rbBhYojhE4SHx4ZongyxTpREE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)