UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fPmK7+k4C8q5GvasSQqocY2d0mbcKIddLJexkJP9gk='
WHERE
key_id = '7ea8897bf26aca41930f9ccddb5c4cbd5fbe9bfaffcd80e8a16ab4d3c195bde7'
AND (
token = '0fPmK7+k4C8q5GvasSQqocY2d0mbcKIddLJexkJP9gk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)