UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxAVNlC+CHU1Y8Ne3Jouo4KyNCv5Frt36gbwCoEs/fA='
WHERE
key_id = '43e9d3e1d6905141c309438e3cefbc7d216a3f7672ae187d8f14531c29fe9fdd'
AND (
token = 'zxAVNlC+CHU1Y8Ne3Jouo4KyNCv5Frt36gbwCoEs/fA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)