UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'moJuol1oPOf7qkpUkafOvvKNmVexu2KCoZLNFM+ovg4='
WHERE
key_id = '7e665b66aee92f7bfdbc33d4fae560248232152b5c82c87ba82636c96c857054'
AND (
token = 'moJuol1oPOf7qkpUkafOvvKNmVexu2KCoZLNFM+ovg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)