UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U+y8V00x69Q25Y+ew57KubUa0SMl6sW3nHGmln2y6S8='
WHERE
key_id = 'd03070a1d5b16ce6939f160cf8e1565265a6d50d917ca343ef04564afeb17f9a'
AND (
token = 'U+y8V00x69Q25Y+ew57KubUa0SMl6sW3nHGmln2y6S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)