UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'efNEP2u/HqszESauFeQ9lFqW23lzRy0zh4xstc+X5G8='
WHERE
key_id = '46ed84a997637230292de621c07493224518035b3d7e4abb39992e0d3ec5d506'
AND (
token = 'efNEP2u/HqszESauFeQ9lFqW23lzRy0zh4xstc+X5G8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)