UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0tNCoTfG8Wl3AxTc5ypF9Dc4rnAC1XmYjqIXIpufck0='
WHERE
key_id = 'ada18a4f194108fc083eb2168281733c88d3f36743f98b32f16d1d8a1ca5ee42'
AND (
token = '0tNCoTfG8Wl3AxTc5ypF9Dc4rnAC1XmYjqIXIpufck0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)