UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Ds0B+zb4acnpe8ZwsWscUUMmNQ4gNRnbtpcOXAdsyg='
WHERE
key_id = '42df229aa3d29ac6c74c01e7ac387671df6fbcb4f2d4ee7f15aeb6e2c29a8537'
AND (
token = '6Ds0B+zb4acnpe8ZwsWscUUMmNQ4gNRnbtpcOXAdsyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)