UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BifPTgjE4dh5+lMMF6vpFHfmkAO8knNGgTVOaNhZ8bI='
WHERE
key_id = '6735c7fae3230b2cbbed64354d38c69e2bdf8816a9251b0b9bfdaf48568bdf7a'
AND (
token = 'BifPTgjE4dh5+lMMF6vpFHfmkAO8knNGgTVOaNhZ8bI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)