UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NXd2pI+mprc1eIGxRTJsAL8SHG+izKpjfg76jGB9+Hg='
WHERE
key_id = 'd237658ee11f2dbe60ff04e0e0566dbcabc8aa4bb9f3a3dfb01a27142694f562'
AND (
token = 'NXd2pI+mprc1eIGxRTJsAL8SHG+izKpjfg76jGB9+Hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)