UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xV1Wsh/tchZ3uax3e11KofiUTvCMQLgGzcyv/0tLILs='
WHERE
key_id = 'e40d2b386cb85312cabd00491d9f9df2cb9ce317038dd166995b5c315b08c94e'
AND (
token = 'xV1Wsh/tchZ3uax3e11KofiUTvCMQLgGzcyv/0tLILs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)