UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KExX9O5zW43MRZC+XM6n6ycQzT/lURefTri+qcPja44='
WHERE
key_id = 'b72f4236996c16fdc536678ceae13b7895acd2c186e4096135ad9f4ad02b27f1'
AND (
token = 'KExX9O5zW43MRZC+XM6n6ycQzT/lURefTri+qcPja44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)