UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I4V8nxsbJGP7j9lZUzi2DTrz2Y6NN594y+TV67DfJVw='
WHERE
key_id = '9a878ef1481b81ee0dae541333d7b99b91003464f9e0566bb9f552e1875f24a1'
AND (
token = 'I4V8nxsbJGP7j9lZUzi2DTrz2Y6NN594y+TV67DfJVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)