UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gmCr2o6W0ZZJStIkaafRoZsphwJgh9aFhd7ERK/NzZA='
WHERE
key_id = '57f7ba79de0a609e38ddf2127fee8a053d14c6d0d087c9e3676a6acc8367fb16'
AND (
token = 'gmCr2o6W0ZZJStIkaafRoZsphwJgh9aFhd7ERK/NzZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)