UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9i3BAPy2O+1a6vYX9ADo0E+HXCVtxHp8xGME4d29cXg='
WHERE
key_id = '34f146609057ce506b0686674bc32ac84f29121b087f77e306118c6607118cb0'
AND (
token = '9i3BAPy2O+1a6vYX9ADo0E+HXCVtxHp8xGME4d29cXg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)