UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'srnH3C9anzelyjKhsNw2iXJNPDbx0Iv5+mSHJgvpKwY='
WHERE
key_id = 'c927c5879e0545c53d29a4d1d36f8c61d1a3fc99be43c83652142c1a838b777e'
AND (
token = 'srnH3C9anzelyjKhsNw2iXJNPDbx0Iv5+mSHJgvpKwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)