UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HTiMetE1f5El81wZUQ/miST1WQOvgvpLyO7scR+oz7k='
WHERE
key_id = '7f420bd78ae80305c28dbc0cc8ca1836ef04ae68db7e306932acf5d15ee0a198'
AND (
token = 'HTiMetE1f5El81wZUQ/miST1WQOvgvpLyO7scR+oz7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)