UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cpYb72hSC8bz8Gik1fl4NxFiJK6yeczcXiCMeUMDii4='
WHERE
key_id = '923b57c1471e056fa79999e405b2d346543dd8a85567d0b0379e2c8cf4d76abe'
AND (
token = 'cpYb72hSC8bz8Gik1fl4NxFiJK6yeczcXiCMeUMDii4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)